
 create table qna_board(
	qna_no number primary key,
	qna_title varchar2(1000) not null,
	qna_writer varchar2(100) not null,
	qna_content varchar2(4000) not null,
	qna_write_date date not null,
	view_count number not null,
	ref number not null, -- 답변글묶음 번호, 원게시글 번호 
	restep number not null, -- 답변글묶음내 글순서(정렬 오름차순)
	relevel number not null -- 답변글레벨 , 답변의 단계 
	)
drop table qna_board;

drop sequence qna_board_seq;
create sequence qna_board_seq;

select * from qna_board

insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'a','a','aa',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'b','b','bb',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'c','c','cc',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'d','d','dd',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'e','e','ee',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'f','f','ff',sysdate);
insert into qna_board(qna_no,qna_title,qna_writer, qna_content,qna_write_date) values(qna_board_seq.nextval,'g','g','gg',sysdate);

 
